-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jan 04, 2012 at 03:59 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `kkpmonev`
--

-- --------------------------------------------------------

--
-- Table structure for table `ANGGARAN`
--

CREATE TABLE IF NOT EXISTS `ANGGARAN` (
  `IDANGGARAN` int(11) NOT NULL AUTO_INCREMENT,
  `KDANGGARAN` varchar(255) NOT NULL,
  `TAHUN` varchar(4) NOT NULL,
  `DESKRIPSI` text,
  `PAGU` double DEFAULT NULL,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDANGGARAN`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `INDIKATOR_KEG`
--

CREATE TABLE IF NOT EXISTS `INDIKATOR_KEG` (
  `IDINDIKATOR_KEG` int(11) NOT NULL AUTO_INCREMENT,
  `IDSASARAN_KEG` int(11) DEFAULT NULL,
  `KDINDIKATOR_KEG` varchar(255) NOT NULL,
  `DESKRIPSI` text,
  `LEVEL` int(11) DEFAULT NULL,
  `PARENT` int(11) DEFAULT NULL,
  `TARGET_JAN` double DEFAULT NULL,
  `SATUAN_JAN` int(11) DEFAULT NULL,
  `TARGET_FEB` double DEFAULT NULL,
  `SATUAN_FEB` int(11) DEFAULT NULL,
  `TARGET_MAR` double DEFAULT NULL,
  `SATUAN_MAR` int(11) DEFAULT NULL,
  `TARGET_APR` double DEFAULT NULL,
  `SATUAN_APR` int(11) DEFAULT NULL,
  `TARGET_MEI` double DEFAULT NULL,
  `SATUAN_MEI` int(11) DEFAULT NULL,
  `TARGET_JUN` double DEFAULT NULL,
  `SATUAN_JUN` int(11) DEFAULT NULL,
  `TARGET_JUL` double DEFAULT NULL,
  `SATUAN_JUL` int(11) DEFAULT NULL,
  `TARGET_AUG` double DEFAULT NULL,
  `SATUAN_AUG` int(11) DEFAULT NULL,
  `TARGET_SEP` double DEFAULT NULL,
  `SATUAN_SEP` int(11) DEFAULT NULL,
  `TARGET_OCT` double DEFAULT NULL,
  `SATUAN_OCT` int(11) DEFAULT NULL,
  `TARGET_NOV` double DEFAULT NULL,
  `SATUAN_NOV` int(11) DEFAULT NULL,
  `TARGET_DEC` double DEFAULT NULL,
  `SATUAN_DEC` int(11) DEFAULT NULL,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDINDIKATOR_KEG`),
  KEY `FK_RELATIONSHIP_8` (`IDSASARAN_KEG`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;

-- --------------------------------------------------------

--
-- Table structure for table `INDIKATOR_PROG`
--

CREATE TABLE IF NOT EXISTS `INDIKATOR_PROG` (
  `IDINDIKATOR_PROG` int(11) NOT NULL AUTO_INCREMENT,
  `IDSASARAN_PROG` int(11) DEFAULT NULL,
  `KDINDIKATOR_PROG` varchar(255) NOT NULL,
  `DESKRIPSI` text,
  `LEVEL` int(11) DEFAULT NULL,
  `PARENT` int(11) DEFAULT NULL,
  `TARGET_JAN` double DEFAULT NULL,
  `SATUAN_JAN` int(11) DEFAULT NULL,
  `TARGET_FEB` double DEFAULT NULL,
  `SATUAN_FEB` int(11) DEFAULT NULL,
  `TARGET_MAR` double DEFAULT NULL,
  `SATUAN_MAR` int(11) DEFAULT NULL,
  `TARGET_APR` double DEFAULT NULL,
  `SATUAN_APR` int(11) DEFAULT NULL,
  `TARGET_MEI` double DEFAULT NULL,
  `SATUAN_MEI` int(11) DEFAULT NULL,
  `TARGET_JUN` double DEFAULT NULL,
  `SATUAN_JUN` int(11) DEFAULT NULL,
  `TARGET_JUL` double DEFAULT NULL,
  `SATUAN_JUL` int(11) DEFAULT NULL,
  `TARGET_AUG` double DEFAULT NULL,
  `SATUAN_AUG` int(11) DEFAULT NULL,
  `TARGET_SEP` double DEFAULT NULL,
  `SATUAN_SEP` int(11) DEFAULT NULL,
  `TARGET_OCT` double DEFAULT NULL,
  `SATUAN_OCT` int(11) DEFAULT NULL,
  `TARGET_NOV` double DEFAULT NULL,
  `SATUAN_NOV` int(11) DEFAULT NULL,
  `TARGET_DEC` double DEFAULT NULL,
  `SATUAN_DEC` int(11) DEFAULT NULL,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDINDIKATOR_PROG`),
  KEY `FK_RELATIONSHIP_5` (`IDSASARAN_PROG`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `INDIKATOR_UTAMA`
--

CREATE TABLE IF NOT EXISTS `INDIKATOR_UTAMA` (
  `IDINDIKATOR_UTAMA` int(11) NOT NULL AUTO_INCREMENT,
  `NAMA_INDIKATOR` varchar(255) NOT NULL,
  `IDANGGARAN` int(11) DEFAULT NULL,
  `TARGET` double DEFAULT NULL,
  `REALISASI` double DEFAULT NULL,
  `USER` int(11) NOT NULL,
  `UPDATED_AT` datetime NOT NULL,
  `STATUS` int(11) NOT NULL,
  PRIMARY KEY (`IDINDIKATOR_UTAMA`),
  KEY `FK_REL_INDIKATOR_UTAMA` (`IDANGGARAN`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `KEGIATAN`
--

CREATE TABLE IF NOT EXISTS `KEGIATAN` (
  `IDKEGIATAN` int(11) NOT NULL AUTO_INCREMENT,
  `IDPROGRAM` int(11) DEFAULT NULL,
  `KDKEGIATAN` varchar(255) NOT NULL,
  `DESKRIPSI` text,
  `PAGU` double DEFAULT NULL,
  `ID_UNIT_ORGANISASI` int(11) DEFAULT NULL,
  `PEJABAT` int(11) DEFAULT NULL,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDKEGIATAN`),
  KEY `FK_RELATIONSHIP_3` (`IDPROGRAM`),
  KEY `FK_RELATIONSHIP_UNIT_KEG` (`ID_UNIT_ORGANISASI`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Table structure for table `KOMPONEN_KEG`
--

CREATE TABLE IF NOT EXISTS `KOMPONEN_KEG` (
  `IDKOMPONEN_KEG` int(11) NOT NULL AUTO_INCREMENT,
  `IDINDIKATOR_KEG` int(11) DEFAULT NULL,
  `KDKOMPONEN_KEG` varchar(255) NOT NULL,
  `LEVEL` int(11) DEFAULT NULL,
  `PARENT` int(11) DEFAULT NULL,
  `NAMA_KOMPONEN` varchar(255) DEFAULT NULL,
  `PAGU` double DEFAULT NULL,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDKOMPONEN_KEG`),
  KEY `FK_RELATIONSHIP_9` (`IDINDIKATOR_KEG`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `KOMPONEN_PROG`
--

CREATE TABLE IF NOT EXISTS `KOMPONEN_PROG` (
  `IDKOMPONEN_PROG` int(11) NOT NULL AUTO_INCREMENT,
  `IDINDIKATOR_PROG` int(11) DEFAULT NULL,
  `KDKOMPONEN_PROG` varchar(255) NOT NULL,
  `LEVEL` int(11) DEFAULT NULL,
  `PARENT` int(11) DEFAULT NULL,
  `NAMA_KOMPONEN` varchar(255) DEFAULT NULL,
  `PAGU` double DEFAULT NULL,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDKOMPONEN_PROG`),
  KEY `FK_RELATIONSHIP_6` (`IDINDIKATOR_PROG`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `PROGRAM`
--

CREATE TABLE IF NOT EXISTS `PROGRAM` (
  `IDPROGRAM` int(11) NOT NULL AUTO_INCREMENT,
  `IDANGGARAN` int(11) DEFAULT NULL,
  `KDPROGRAM` varchar(255) NOT NULL,
  `DESKRIPSI` text,
  `PAGU` double DEFAULT NULL,
  `ID_UNIT_ORGANISASI` int(11) DEFAULT NULL,
  `PEJABAT` int(11) DEFAULT NULL,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDPROGRAM`),
  KEY `FK_RELATIONSHIP_2` (`IDANGGARAN`),
  KEY `FK_RELATIONSHIP_UNIT_PROG` (`ID_UNIT_ORGANISASI`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `REALISASI_IND_KEGIATAN`
--

CREATE TABLE IF NOT EXISTS `REALISASI_IND_KEGIATAN` (
  `IDREALISASI_IND_KEG` int(11) NOT NULL AUTO_INCREMENT,
  `IDINDIKATOR_KEG` int(11) DEFAULT NULL,
  `BULAN` int(11) NOT NULL,
  `VOLUME` double DEFAULT NULL,
  `IDSATUAN` int(11) DEFAULT NULL,
  `PERSENTASE` double DEFAULT NULL,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDREALISASI_IND_KEG`),
  KEY `FK_RELATIONSHIP_11` (`IDINDIKATOR_KEG`),
  KEY `FK_RELATIONSHIP_17` (`IDSATUAN`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `REALISASI_IND_PROG`
--

CREATE TABLE IF NOT EXISTS `REALISASI_IND_PROG` (
  `IDREALISASI_IND_PROG` int(11) NOT NULL AUTO_INCREMENT,
  `IDINDIKATOR_PROG` int(11) DEFAULT NULL,
  `BULAN` int(11) NOT NULL,
  `VOLUME` double DEFAULT NULL,
  `IDSATUAN` int(11) DEFAULT NULL,
  `PERSENTASE` double DEFAULT NULL,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDREALISASI_IND_PROG`),
  KEY `FK_RELATIONSHIP_10` (`IDINDIKATOR_PROG`),
  KEY `FK_RELATIONSHIP_16` (`IDSATUAN`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `REALISASI_KOM_KEG`
--

CREATE TABLE IF NOT EXISTS `REALISASI_KOM_KEG` (
  `IDREALISASI_KOM_KEG` int(11) NOT NULL AUTO_INCREMENT,
  `IDKOMPONEN_KEG` int(11) DEFAULT NULL,
  `REALISASI` double NOT NULL,
  `PERSENTASE` double NOT NULL,
  `PERMASALAHAN` text,
  `TINDAK_LANJUT` text,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDREALISASI_KOM_KEG`),
  KEY `FK_RELATIONSHIP_15` (`IDKOMPONEN_KEG`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `REALISASI_KOM_PROG`
--

CREATE TABLE IF NOT EXISTS `REALISASI_KOM_PROG` (
  `IDREALISASI_KOM_PROG` int(11) NOT NULL AUTO_INCREMENT,
  `IDKOMPONEN_PROG` int(11) DEFAULT NULL,
  `REALISASI` double NOT NULL,
  `PERSENTASE` double NOT NULL,
  `PERMASALAHAN` text,
  `TINDAK_LANJUT` text,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDREALISASI_KOM_PROG`),
  KEY `FK_RELATIONSHIP_14` (`IDKOMPONEN_PROG`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `ROLE`
--

CREATE TABLE IF NOT EXISTS `ROLE` (
  `IDROLE` int(11) NOT NULL AUTO_INCREMENT,
  `NAMA_ROLE` varchar(50) DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDROLE`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Table structure for table `SASARAN_KEG`
--

CREATE TABLE IF NOT EXISTS `SASARAN_KEG` (
  `IDSASARAN_KEG` int(11) NOT NULL AUTO_INCREMENT,
  `IDKEGIATAN` int(11) DEFAULT NULL,
  `KDSASARAN_KEG` varchar(255) NOT NULL,
  `DESKRIPSI` text,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDSASARAN_KEG`),
  KEY `FK_RELATIONSHIP_7` (`IDKEGIATAN`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Table structure for table `SASARAN_PROG`
--

CREATE TABLE IF NOT EXISTS `SASARAN_PROG` (
  `IDSASARAN_PROG` int(11) NOT NULL AUTO_INCREMENT,
  `IDPROGRAM` int(11) DEFAULT NULL,
  `KDSASARAN_PROG` varchar(255) NOT NULL,
  `DESKRIPSI` text,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDSASARAN_PROG`),
  KEY `FK_RELATIONSHIP_4` (`IDPROGRAM`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Table structure for table `SATUAN`
--

CREATE TABLE IF NOT EXISTS `SATUAN` (
  `IDSATUAN` int(11) NOT NULL AUTO_INCREMENT,
  `NAMA_SATUAN` varchar(255) NOT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`IDSATUAN`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- Table structure for table `UNIT_ORGANISASI`
--

CREATE TABLE IF NOT EXISTS `UNIT_ORGANISASI` (
  `ID_UNIT_ORGANISASI` int(11) NOT NULL AUTO_INCREMENT,
  `NAMA_UNIT` varchar(255) NOT NULL,
  `ESELON` int(11) NOT NULL,
  `DIREKTUR` int(11) DEFAULT NULL,
  `USER` int(11) DEFAULT NULL,
  `UPDATED_AT` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_UNIT_ORGANISASI`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

--
-- Table structure for table `USERS`
--

CREATE TABLE IF NOT EXISTS `USERS` (
  `ID_USER` int(11) NOT NULL AUTO_INCREMENT,
  `IDROLE` int(11) DEFAULT NULL,
  `NAMA` varchar(100) NOT NULL,
  `JABATAN` varchar(100) NOT NULL,
  `ID_UNIT_ORGANISASI` int(11) NOT NULL,
  `EMAIL` varchar(100) DEFAULT NULL,
  `USERNAME` varchar(100) NOT NULL,
  `PASSWORD` varchar(100) NOT NULL,
  `STATUS` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_USER`),
  KEY `FK_RELATIONSHIP_18` (`IDROLE`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `INDIKATOR_KEG`
--
ALTER TABLE `INDIKATOR_KEG`
  ADD CONSTRAINT `FK_RELATIONSHIP_8` FOREIGN KEY (`IDSASARAN_KEG`) REFERENCES `SASARAN_KEG` (`IDSASARAN_KEG`);

--
-- Constraints for table `INDIKATOR_PROG`
--
ALTER TABLE `INDIKATOR_PROG`
  ADD CONSTRAINT `FK_RELATIONSHIP_5` FOREIGN KEY (`IDSASARAN_PROG`) REFERENCES `SASARAN_PROG` (`IDSASARAN_PROG`);

--
-- Constraints for table `INDIKATOR_UTAMA`
--
ALTER TABLE `INDIKATOR_UTAMA`
  ADD CONSTRAINT `FK_REL_INDIKATOR_UTAMA` FOREIGN KEY (`IDANGGARAN`) REFERENCES `ANGGARAN` (`IDANGGARAN`);

--
-- Constraints for table `KEGIATAN`
--
ALTER TABLE `KEGIATAN`
  ADD CONSTRAINT `FK_RELATIONSHIP_3` FOREIGN KEY (`IDPROGRAM`) REFERENCES `PROGRAM` (`IDPROGRAM`),
  ADD CONSTRAINT `FK_RELATIONSHIP_UNIT_KEG` FOREIGN KEY (`ID_UNIT_ORGANISASI`) REFERENCES `UNIT_ORGANISASI` (`ID_UNIT_ORGANISASI`);

--
-- Constraints for table `KOMPONEN_KEG`
--
ALTER TABLE `KOMPONEN_KEG`
  ADD CONSTRAINT `FK_RELATIONSHIP_9` FOREIGN KEY (`IDINDIKATOR_KEG`) REFERENCES `INDIKATOR_KEG` (`IDINDIKATOR_KEG`);

--
-- Constraints for table `KOMPONEN_PROG`
--
ALTER TABLE `KOMPONEN_PROG`
  ADD CONSTRAINT `FK_RELATIONSHIP_6` FOREIGN KEY (`IDINDIKATOR_PROG`) REFERENCES `INDIKATOR_PROG` (`IDINDIKATOR_PROG`);

--
-- Constraints for table `PROGRAM`
--
ALTER TABLE `PROGRAM`
  ADD CONSTRAINT `FK_RELATIONSHIP_2` FOREIGN KEY (`IDANGGARAN`) REFERENCES `ANGGARAN` (`IDANGGARAN`),
  ADD CONSTRAINT `FK_RELATIONSHIP_UNIT_PROG` FOREIGN KEY (`ID_UNIT_ORGANISASI`) REFERENCES `UNIT_ORGANISASI` (`ID_UNIT_ORGANISASI`);

--
-- Constraints for table `REALISASI_IND_KEGIATAN`
--
ALTER TABLE `REALISASI_IND_KEGIATAN`
  ADD CONSTRAINT `FK_RELATIONSHIP_11` FOREIGN KEY (`IDINDIKATOR_KEG`) REFERENCES `INDIKATOR_KEG` (`IDINDIKATOR_KEG`),
  ADD CONSTRAINT `FK_RELATIONSHIP_17` FOREIGN KEY (`IDSATUAN`) REFERENCES `SATUAN` (`IDSATUAN`);

--
-- Constraints for table `REALISASI_IND_PROG`
--
ALTER TABLE `REALISASI_IND_PROG`
  ADD CONSTRAINT `FK_RELATIONSHIP_10` FOREIGN KEY (`IDINDIKATOR_PROG`) REFERENCES `INDIKATOR_PROG` (`IDINDIKATOR_PROG`),
  ADD CONSTRAINT `FK_RELATIONSHIP_16` FOREIGN KEY (`IDSATUAN`) REFERENCES `SATUAN` (`IDSATUAN`);

--
-- Constraints for table `REALISASI_KOM_KEG`
--
ALTER TABLE `REALISASI_KOM_KEG`
  ADD CONSTRAINT `FK_RELATIONSHIP_15` FOREIGN KEY (`IDKOMPONEN_KEG`) REFERENCES `KOMPONEN_KEG` (`IDKOMPONEN_KEG`);

--
-- Constraints for table `REALISASI_KOM_PROG`
--
ALTER TABLE `REALISASI_KOM_PROG`
  ADD CONSTRAINT `FK_RELATIONSHIP_14` FOREIGN KEY (`IDKOMPONEN_PROG`) REFERENCES `KOMPONEN_PROG` (`IDKOMPONEN_PROG`);

--
-- Constraints for table `SASARAN_KEG`
--
ALTER TABLE `SASARAN_KEG`
  ADD CONSTRAINT `FK_RELATIONSHIP_7` FOREIGN KEY (`IDKEGIATAN`) REFERENCES `KEGIATAN` (`IDKEGIATAN`);

--
-- Constraints for table `SASARAN_PROG`
--
ALTER TABLE `SASARAN_PROG`
  ADD CONSTRAINT `FK_RELATIONSHIP_4` FOREIGN KEY (`IDPROGRAM`) REFERENCES `PROGRAM` (`IDPROGRAM`);

--
-- Constraints for table `USERS`
--
ALTER TABLE `USERS`
  ADD CONSTRAINT `FK_RELATIONSHIP_18` FOREIGN KEY (`IDROLE`) REFERENCES `ROLE` (`IDROLE`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
